package com.softer.wxzj.mapper;

import com.softer.wxzj.entity.ExpPayReqDetail;
import com.softer.wxzj.entity.ExpProjectReqDetail;
import com.softer.wxzj.entity.OwnerSignature;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.math.BigDecimal;
import java.util.List;

@Repository
public interface ExpPayReqDetailMapper {
    int deleteByPrimaryKey(String id);
    int deleteByPayReqId(@Param("id") String id);
    int insert(ExpPayReqDetail record);

    int insertSelective(ExpPayReqDetail record);

    ExpPayReqDetail selectByPrimaryKey(String id);

    int updateByPrimaryKeySelective(ExpPayReqDetail record);

    int updateByPrimaryKey(ExpPayReqDetail record);

    List<ExpPayReqDetail> getInfoByPayReqId(@Param("payReqId") String payReqId);
    /**
     * 拨款批次打印详情
     * @param payReqId    拨款批次id
     * @return 结果
     */
    List<ExpPayReqDetail> selectByPayReqId(@Param("payReqId") String payReqId);
    ExpPayReqDetail selectByPayReqIdSum(@Param("payReqId") String payReqId);
    OwnerSignature getOwnerSignatureInfo(@Param("reqId") String reqId,@Param("houseId") String houseId);


    int deleteByReqId(@Param("reqId") String reqId);
    ExpPayReqDetail getSumByReqId(@Param("reqId") String reqId, @Param("houseId") String houseId);
    ExpPayReqDetail getInfoByPayReqIdAndHouseId(@Param("payReqId") String payReqId, @Param("houseId") String houseId);
    BigDecimal selectSumByBuildId(@Param("rooms") String rooms,@Param("payReqId") String payReqId);
   }
